<?php
session_start();
if(!$_SESSION["trv3_07"]){
	header("location:../../../login.php");
	exit;
}
require "../../../resources/v1.php";
?>
<html>
	<head>
		<link rel="stylesheet" type="text/css" href="../../../style/data_v1.css" />
	</head>
	<body onLoad="inicializar()">
		<div id="Conteiner">
			<form id="DT" name="Datos" method ="POST" onsubmit="return false;">
				<div id="Tabla" style="overflow-y:scroll; height:320; width:830;">
					<table id="Tbl" width="810" border="1" align="center" cellpadding="1" class="Normal" cellspacing="0" bordercolor="#DBE5F1" rules="alls" frame="hsides">
						<tr bgcolor="#B6DDC7" align="center" class="SubT" height="26">
							<td width="65">Autos</td>
							<td width="65">Acta</td>
							<td width="90">Fecha</td>
							<td width="100">Documento</td>
							<td>Nombre</td>
						</tr>
						<?
						$i = 0;
						$conexion = server_reconnect();
						$query = "select e.`autos`,e.`tip`,date(e.`fech`) `fech`,e.`nro`,concat(i.`ape`,', ',i.`nom`) `nom`,i.`nro` `doc` from `exp` e,`inf` i where e.`est`=0 and e.`fech`>'2010-10-14' and e.`fech`<subdate(now(),40) and e.`inf`=i.`id` and i.`nro`<>0 order by e.`fech`";
						$result = mysql_query( $query, $conexion);
						while($mxcel = @mysql_fetch_array($result)){
							if($i){
								echo "<tr bgcolor='#D8FFE9' height='26'>";
								$i = 0;
							}else{
								echo "<tr height='26'>";
								$i = 1;
							}
							echo "<td align=\"left\">".$mxcel['autos']."</td>";
							echo "<td align=\"left\">".$mxcel['nro']."</td>";
							echo "<td align=\"center\">".$mxcel['fech']."</td>";
							echo "<td align=\"left\">".$mxcel['doc']."</td>";
							echo "<td align=\"left\">".strtoupper($mxcel['nom'])."</td>";
							echo "</tr> \n";
						}
						server_disconnect( $conexion);
						?>
					</table>
				</div>
			</form>
		</div>
	</body>
</html>